<template>
    <div class="app-container">
        <el-form :model="queryParams" ref="queryForm" size="small" :inline="true" v-show="showSearch" label-width="100px">
            <el-form-item label="数据库名称" prop="dbName">
                <el-input v-model="queryParams.dbName" placeholder="请输入数据库名称" clearable @keyup.enter.native="handleQuery" />
            </el-form-item>
            <el-form-item>
                <el-button type="primary" icon="el-icon-search" size="mini" @click="handleQuery">搜索</el-button>
                <el-button icon="el-icon-refresh" size="mini" @click="resetQuery">重置</el-button>
            </el-form-item>
        </el-form>

        <el-row :gutter="10" class="mb8">
            <el-col :span="1.5">
                <el-button type="primary" plain icon="el-icon-plus" size="mini" @click="handleAdd"
                    v-hasPermi="['system:database:add']">新增</el-button>
            </el-col>
            <right-toolbar :showSearch.sync="showSearch" @queryTable="getList"></right-toolbar>
        </el-row>

        <el-table v-loading="loading" :data="databaseList" @selection-change="handleSelectionChange">
            <!-- <el-table-column type="selection" width="55" align="center" /> -->
            <!-- <el-table-column label="ID" v-show="false" align="center" prop="id" /> -->
            <el-table-column label="#" type="index" width="50">
            </el-table-column>
            <el-table-column label="数据库名称" align="center" prop="dbName" />
            <el-table-column label="数据库类型" align="center" prop="dbType">
                <template slot-scope="scope">
                    <dict-tag :options="dict.type.db_type" :value="scope.row.dbType" />
                </template>
            </el-table-column>
            <el-table-column label="IP" align="center" prop="ip" />
            <el-table-column label="操作" align="center" class-name="small-padding fixed-width">
                <template slot-scope="scope">
                    <el-button size="mini" type="text" icon="el-icon-refresh" @click="handleSynchronize(scope.row)"
                        v-hasPermi="['system:database:edit']">同步</el-button>
                    <el-button size="mini" type="text" icon="el-icon-edit" @click="handleUpdate(scope.row)"
                        v-hasPermi="['system:database:edit']">修改</el-button>
                    <el-button size="mini" type="text" icon="el-icon-delete" @click="handleDelete(scope.row)"
                        v-hasPermi="['system:database:remove']">删除</el-button>
                </template>
            </el-table-column>
        </el-table>

        <pagination v-show="total > 0" :total="total" :page.sync="queryParams.pageNum" :limit.sync="queryParams.pageSize"
            @pagination="getList" />

        <!-- 添加或修改数据源管理对话框 -->
        <el-dialog :title="title" :visible.sync="open" width="800px" append-to-body>
            <el-form ref="form" :inline="true" :model="form" :rules="rules" label-width="100px">
                <el-row>
                    <el-col :span="12">
                        <el-form-item label="数据库名称" prop="dbName">
                            <el-input v-model="form.dbName" placeholder="请输入数据库名称" />
                        </el-form-item>
                    </el-col>
                    <el-col :span="12">
                        <el-form-item label="数据库类型" prop="dbType">
                            <el-select v-model="form.dbType" placeholder="请选择数据库类型">
                                <el-option v-for="dict in dict.type.db_type" :key="dict.value" :label="dict.label"
                                    :value="dict.value"></el-option>
                            </el-select>
                        </el-form-item>
                    </el-col>
                </el-row>
                <el-row>
                    <el-col :span="12">
                        <el-form-item label="IP" prop="ip">
                            <el-input v-model="form.ip" placeholder="请输入IP" />
                        </el-form-item>
                    </el-col>
                    <el-col :span="12">
                        <el-form-item label="SCHEMA" prop="schemal">
                            <el-input v-model="form.schemal" placeholder="请输入SCHEMA" />
                        </el-form-item>
                    </el-col>
                </el-row>
                <el-row>
                    <el-col :span="12">
                        <el-form-item label="端口" prop="port">
                            <el-input v-model="form.port" placeholder="请输入端口" />
                        </el-form-item>
                    </el-col>
                    <el-col :span="12">
                        <el-form-item label="用户名" prop="user">
                            <el-input v-model="form.user" placeholder="请输入用户名" />
                        </el-form-item>
                    </el-col>
                </el-row>
                <el-row>
                    <el-col :span="12">
                        <el-form-item label="密码" prop="password">
                            <el-input type="password" v-model="form.password" placeholder="请输入密码" />
                        </el-form-item>
                    </el-col>
                    <el-col :span="12">
                        <el-form-item>
                            <el-link :underline="false" @click="verify" type="success">测试连接</el-link>
                        </el-form-item>
                    </el-col>
                </el-row>
            </el-form>
            <div slot="footer" class="dialog-footer">
                <el-button type="primary" @click="submitForm">确 定</el-button>
                <el-button @click="cancel">取 消</el-button>
            </div>
        </el-dialog>
    </div>
</template>
  
<script>
import { listDatabase, getDatabase, delDatabase, addDatabase, updateDatabase,verify,synchronize } from "@/api/system/database";

export default {
    name: "Database",
    dicts: ['db_type'],
    data() {
        return {
            // 遮罩层
            loading: true,
            // 选中数组
            ids: [],
            // 非单个禁用
            single: true,
            // 非多个禁用
            multiple: true,
            // 显示搜索条件
            showSearch: true,
            // 总条数
            total: 0,
            // 数据源管理表格数据
            databaseList: [],
            // 弹出层标题
            title: "",
            // 是否显示弹出层
            open: false,
            // 查询参数
            queryParams: {
                pageNum: 1,
                pageSize: 10,
                dbName: null,
            },
            // 表单参数
            form: {},
            // 表单校验
            rules: {
                dbName: [
                    { required: true, message: "数据库名称不能为空", trigger: "blur" }
                ],
                dbType: [
                    { required: true, message: "数据库类型不能为空", trigger: "change" }
                ],
                ip: [
                    { required: true, message: "IP不能为空", trigger: "blur" }
                ],
                schemal: [
                    { required: true, message: "SCHEMA不能为空", trigger: "blur" }
                ],
                port: [
                    { required: true, message: "端口不能为空", trigger: "blur" }
                ],
                user: [
                    { required: true, message: "用户名不能为空", trigger: "blur" }
                ],
                password: [
                    { required: true, message: "密码不能为空", trigger: "blur" }
                ],
            }
        };
    },
    created() {
        this.getList();
    },
    methods: {
        /** 查询数据源管理列表 */
        getList() {
            this.loading = true;
            listDatabase(this.queryParams).then(response => {
                this.databaseList = response.rows;
                this.total = response.total;
                this.loading = false;
            });
        },
        // 取消按钮
        cancel() {
            this.open = false;
            this.reset();
        },
        // 表单重置
        reset() {
            this.form = {
                id: null,
                dbName: null,
                bureauId: null,
                bureauName: null,
                classify: null,
                dbType: null,
                url: null,
                driver: null,
                ip: null,
                schemal: null,
                port: null,
                user: null,
                password: null,
                znodeParent: null,
                sshIp: null,
                sshUser: null,
                sshPassword: null,
                sshPort: null,
                createBy: null,
                createTime: null,
                updateBy: null,
                updateTime: null,
                delFlag: null,
                orgDb: null,
                valid: null
            };
            this.resetForm("form");
        },
        /** 搜索按钮操作 */
        handleQuery() {
            this.queryParams.pageNum = 1;
            this.getList();
        },
        /** 重置按钮操作 */
        resetQuery() {
            this.resetForm("queryForm");
            this.handleQuery();
        },
        // 多选框选中数据
        handleSelectionChange(selection) {
            this.ids = selection.map(item => item.id)
            this.single = selection.length !== 1
            this.multiple = !selection.length
        },
        /** 新增按钮操作 */
        handleAdd() {
            this.reset();
            this.open = true;
            this.title = "添加数据源管理";
        },
        /** 修改按钮操作 */
        handleUpdate(row) {
            this.reset();
            const id = row.id || this.ids
            getDatabase(id).then(response => {
                this.form = response.data;
                this.open = true;
                this.title = "修改数据源管理";
            });
        },
        handleSynchronize(row){
            synchronize({dbId:row.id}).then(response => {
                this.$modal.msgSuccess("同步成功!");
            });
        },
        verify() {
            this.$refs["form"].validate(valid => {
                if (valid) {
                    verify(this.form).then(response => {
                        this.$modal.msgSuccess(response.msg);
                    });
                }
            });
        },
        /** 提交按钮 */
        submitForm() {
            this.$refs["form"].validate(valid => {
                if (valid) {
                    if (this.form.id != null) {
                        updateDatabase(this.form).then(response => {
                            this.$modal.msgSuccess("修改成功");
                            this.open = false;
                            this.getList();
                        });
                    } else {
                        addDatabase(this.form).then(response => {
                            this.$modal.msgSuccess("新增成功");
                            this.open = false;
                            this.getList();
                        });
                    }
                }
            });
        },
        /** 删除按钮操作 */
        handleDelete(row) {
            const ids = row.id || this.ids;
            this.$modal.confirm('是否确认删除数据源管理编号为"' + ids + '"的数据项？').then(function () {
                return delDatabase(ids);
            }).then(() => {
                this.getList();
                this.$modal.msgSuccess("删除成功");
            }).catch(() => { });
        },
        /** 导出按钮操作 */
        handleExport() {
            this.download('system/database/export', {
                ...this.queryParams
            }, `database_${new Date().getTime()}.xlsx`)
        }
    }
};
</script>
  